SQL Explorer
This screen is used to inquire or update data stored in the mobile device’s database. Thin client solutions do not have users, menu, applications, etc. and therefore do not contain databases.
Click on the Remote SQL Explorer menu option and then select the active device. Enter any valid SQL statement, or multiple SQL statements separated by a semi-colon in the Remote SQL Query window and click the Execute menu option. In the case of multiple SQL statements, the statement that contains the blinking I-beam cursor or has been highlighted will be executed.
The Options menu item allows for a restricted number of rows to be returned in case the statements will bring back more data than desired. It will also switch the grid display into a list of previously executed SQL statements for easily repeating previous statements.